Implementation and Evaluations of Recovery Method for Batch Update

For the operation of the nonstop service systems, some methods have been put to practical use to perform the batch update concurrently with the online entries. However, the whole batch update cannot be executed as a transaction by the conventional methods. So, in the case where a transaction failure occurs in the batch update, there is the problem that the rollback of the update cannot be executed with maintaining the isolation from the online entries. For this problem, we have proposed the temporal update method, by which the batch update can be executed as a transaction. In this study, we show the consistency of the batch update result can be checked before the commit by this method, even in the case of the concurrent execution with the online entries. Furthermore, we show the following: the recovery of the transaction failure by this method can be executed without affecting to the online entries; it is more efficient than the conventional methods.